﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.Mail
{
    public partial class WebMailInfo
    {
        public const string INSERT_SQL = "insert into [WebMail] ( [ID], [Name], [Body], [BodySize], [UserID], [MailGuid], [FolderID], [FromName], [FromAddr], [ToAddr], [CCAddr], [AccountAddr], [InputTime], [HasAttachment], [HasDownload], [Status]) values ( @ID, @Name, @Body, @BodySize, @UserID, @MailGuid, @FolderID, @FromName, @FromAddr, @ToAddr, @CCAddr, @AccountAddr, @InputTime, @HasAttachment, @HasDownload, @Status)";
        public const string UPDATE_SQL = "update [WebMail] set  [ID] = @ID, [Name] = @Name, [Body] = @Body, [BodySize] = @BodySize, [UserID] = @UserID, [MailGuid] = @MailGuid, [FolderID] = @FolderID, [FromName] = @FromName, [FromAddr] = @FromAddr, [ToAddr] = @ToAddr, [CCAddr] = @CCAddr, [AccountAddr] = @AccountAddr, [InputTime] = @InputTime, [HasAttachment] = @HasAttachment, [HasDownload] = @HasDownload, [Status] = @Status where ID = @ID";
        public WebMailInfo() { }
        public Int32 ID
        {
            get;
            set;
        }
        public String Name
        {
            get;
            set;
        }
        public String Body
        {
            get;
            set;
        }
        public Int32 BodySize
        {
            get;
            set;
        }
        public Int32 UserID
        {
            get;
            set;
        }
        public String MailGuid
        {
            get;
            set;
        }
        public Int32 FolderID
        {
            get;
            set;
        }
        public String FromName
        {
            get;
            set;
        }
        public String FromAddr
        {
            get;
            set;
        }
        public String ToAddr
        {
            get;
            set;
        }
        public String CCAddr
        {
            get;
            set;
        }
        public String AccountAddr
        {
            get;
            set;
        }
        public DateTime InputTime
        {
            get;
            set;
        }
        public Boolean HasAttachment
        {
            get;
            set;
        }
        public Boolean HasDownload
        {
            get;
            set;
        }
        public Int32 Status
        {
            get;
            set;
        }
    }

}
